package com.bx.implatform.growUp.mapper;

import com.bx.implatform.growUp.entity.Bridge;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface ConserveMapper {
    /**
     * 桥梁概况
     *
     * @return
     */
    @Select("""
            SELECT "id", "code", "name", "organ_id", "road_id", "maint_center_id", "span_combination", "up_down_stream", "bridge_category", "total_length", "total_width", "design_load", "latest_tech_condition", "maintenance_level", "construction_org", "design_org", "construction_unit", "completion_time", "create_time", "update_time", "spare1", "Spare2", "spare3", "spare4"
            FROM "data_center"."bridge";
            """)
    List<Bridge> bridge();
}
